<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<HTML
><HEAD
><TITLE
>DROP DATABASE</TITLE
><META
NAME="GENERATOR"
CONTENT="Modular DocBook HTML Stylesheet Version 1.79"><LINK
REV="MADE"
HREF="mailto:pgsql-docs@postgresql.org"><LINK
REL="HOME"
TITLE="PostgreSQL 9.1.2 Documentation"
HREF="index.html"><LINK
REL="UP"
TITLE="SQL Commands"
HREF="sql-commands.html"><LINK
REL="PREVIOUS"
TITLE="DROP CONVERSION"
HREF="sql-dropconversion.html"><LINK
REL="NEXT"
TITLE="DROP DOMAIN"
HREF="sql-dropdomain.html"><LINK
REL="STYLESHEET"
TYPE="text/css"
HREF="stylesheet.css"><META
HTTP-EQUIV="Content-Type"
CONTENT="text/html; charset=ISO-8859-1"><META
NAME="creation"
CONTENT="2011-12-01T22:07:59"></HEAD
><BODY
CLASS="REFENTRY"
><DIV
CLASS="NAVHEADER"
><TABLE
SUMMARY="Header navigation table"
WIDTH="100%"
BORDER="0"
CELLPADDING="0"
CELLSPACING="0"
><TR
><TH
COLSPAN="5"
ALIGN="center"
VALIGN="bottom"
><A
HREF="index.html"
>PostgreSQL 9.1.2 Documentation</A
></TH
></TR
><TR
><TD
WIDTH="10%"
ALIGN="left"
VALIGN="top"
><A
TITLE="DROP CONVERSION"
HREF="sql-dropconversion.html"
ACCESSKEY="P"
>Prev</A
></TD
><TD
WIDTH="10%"
ALIGN="left"
VALIGN="top"
><A
HREF="sql-commands.html"
ACCESSKEY="U"
>Up</A
></TD
><TD
WIDTH="60%"
ALIGN="center"
VALIGN="bottom"
></TD
><TD
WIDTH="20%"
ALIGN="right"
VALIGN="top"
><A
TITLE="DROP DOMAIN"
HREF="sql-dropdomain.html"
ACCESSKEY="N"
>Next</A
></TD
></TR
></TABLE
><HR
ALIGN="LEFT"
WIDTH="100%"></DIV
><H1
><A
NAME="SQL-DROPDATABASE"
></A
>DROP DATABASE</H1
><DIV
CLASS="REFNAMEDIV"
><A
NAME="AEN70245"
></A
><H2
>Name</H2
>DROP DATABASE&nbsp;--&nbsp;remove a database</DIV
><DIV
CLASS="REFSYNOPSISDIV"
><A
NAME="AEN70250"
></A
><H2
>Synopsis</H2
><PRE
CLASS="SYNOPSIS"
>DROP DATABASE [ IF EXISTS ] <TT
CLASS="REPLACEABLE"
><I
>name</I
></TT
></PRE
></DIV
><DIV
CLASS="REFSECT1"
><A
NAME="AEN70253"
></A
><H2
>Description</H2
><P
>   <TT
CLASS="COMMAND"
>DROP DATABASE</TT
> drops a database. It removes the
   catalog entries for the database and deletes the directory
   containing the data.  It can only be executed by the database owner.
   Also, it cannot be executed while you or anyone else are connected
   to the target database.  (Connect to <TT
CLASS="LITERAL"
>postgres</TT
> or any
   other database to issue this command.)
  </P
><P
>   <TT
CLASS="COMMAND"
>DROP DATABASE</TT
> cannot be undone.  Use it with care!
  </P
></DIV
><DIV
CLASS="REFSECT1"
><A
NAME="AEN70260"
></A
><H2
>Parameters</H2
><P
></P
><DIV
CLASS="VARIABLELIST"
><DL
><DT
><TT
CLASS="LITERAL"
>IF EXISTS</TT
></DT
><DD
><P
>      Do not throw an error if the database does not exist. A notice is issued
      in this case.
     </P
></DD
><DT
><TT
CLASS="REPLACEABLE"
><I
>name</I
></TT
></DT
><DD
><P
>      The name of the database to remove.
     </P
></DD
></DL
></DIV
></DIV
><DIV
CLASS="REFSECT1"
><A
NAME="AEN70273"
></A
><H2
>Notes</H2
><P
>    <TT
CLASS="COMMAND"
>DROP DATABASE</TT
> cannot be executed inside a transaction
    block.
   </P
><P
>   This command cannot be executed while connected to the target
   database. Thus, it might be more convenient to use the program
   <A
HREF="app-dropdb.html"
><SPAN
CLASS="APPLICATION"
>dropdb</SPAN
></A
> instead,
   which is a wrapper around this command.
  </P
></DIV
><DIV
CLASS="REFSECT1"
><A
NAME="AEN70279"
></A
><H2
>Compatibility</H2
><P
>   There is no <TT
CLASS="COMMAND"
>DROP DATABASE</TT
> statement in the SQL standard.
  </P
></DIV
><DIV
CLASS="REFSECT1"
><A
NAME="AEN70283"
></A
><H2
>See Also</H2
><A
HREF="sql-createdatabase.html"
>CREATE DATABASE</A
></DIV
><DIV
CLASS="NAVFOOTER"
><HR
ALIGN="LEFT"
WIDTH="100%"><TABLE
SUMMARY="Footer navigation table"
WIDTH="100%"
BORDER="0"
CELLPADDING="0"
CELLSPACING="0"
><TR
><TD
WIDTH="33%"
ALIGN="left"
VALIGN="top"
><A
HREF="sql-dropconversion.html"
ACCESSKEY="P"
>Prev</A
></TD
><TD
WIDTH="34%"
ALIGN="center"
VALIGN="top"
><A
HREF="index.html"
ACCESSKEY="H"
>Home</A
></TD
><TD
WIDTH="33%"
ALIGN="right"
VALIGN="top"
><A
HREF="sql-dropdomain.html"
ACCESSKEY="N"
>Next</A
></TD
></TR
><TR
><TD
WIDTH="33%"
ALIGN="left"
VALIGN="top"
>DROP CONVERSION</TD
><TD
WIDTH="34%"
ALIGN="center"
VALIGN="top"
><A
HREF="sql-commands.html"
ACCESSKEY="U"
>Up</A
></TD
><TD
WIDTH="33%"
ALIGN="right"
VALIGN="top"
>DROP DOMAIN</TD
></TR
></TABLE
></DIV
></BODY
></HTML
>